2013-04-29 - 5579.900 - Rel Notes - EPM Reports - Release 004 #BIReleases2013
Release Notes:
5579.900 - Contracts - EPM220
Admin Info
Purpose
|
Including Region parameter in EPM220 - License Scorecard
|
Release No
|
004
|
Submitted
|
04-29-2013
|
Submitted by
|
Praveen Guntuka
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Narendra Koraganji
|
Object(s) Tested By
|
Narendra Koraganji
|
Report Name
EPM220 - License Scorecard
BEx Query
ZMP_OPASA_Q001
ZMP_OPASA_Q002
ZMP_OPASA_Q003
ZMP_OPASA_Q004
ZMP_OPASA_Q005
ZMP_OPASA_Q006
ZMP_OPASA_Q007
ZMP_OPASA_Q008
ZMP_OPASA_Q009
ZMP_OPASA_Q010
ZMP_OPASA_Q011
ZMP_OPASA_Q012
NEC Crystal Reports Standards Check
1. EPM220 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. EPM220 NEC CR checklist has been sent to NEC and also attached here for reference:
EPM220 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
Parameter : 1 - North America
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
124,254,540
|
113,859,068
|
Pass
|
2
|
Last Year Shipped YTD
|
102,491,802
|
102,491,802
|
Pass
|
3
|
Current Year Budget YTD
|
139,112,858
|
139,112,858
|
Pass
|
4
|
Total Open Revenue
|
132,978,809
|
136,945,242
|
Pass
|
5
|
Total Shipped Current Year
|
257,233,349
|
250,804,310
|
Pass
|
6
|
Total Shipped Last Year
|
479,769,642
|
447,596,836
|
Pass
|
7
|
Total Budget Current Year
|
516,707,703
|
516,707,703
|
Pass
|
8
|
TY Quantity
|
11,181,835
|
10,030,062
|
Pass
|
9
|
LY Quantity
|
9,201,612
|
9,201,612
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Parameter : 2 - Emerging Markets
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
5,465,704
|
5,465,704
|
Pass
|
2
|
Last Year Shipped YTD
|
3,745,580
|
3,745,580
|
Pass
|
3
|
Current Year Budget YTD
|
5,869,406
|
5,869,406
|
Pass
|
4
|
Total Open Revenue
|
8,034,106
|
7,734,429
|
Pass
|
5
|
Total Shipped Current Year
|
13,499,810
|
13,200,133
|
Pass
|
6
|
Total Shipped Last Year
|
19,091,204
|
19,091,204
|
Pass
|
7
|
Total Budget Current Year
|
25,420,290
|
25,420,290
|
Pass
|
8
|
TY Quantity
|
350,673
|
350,673
|
Pass
|
9
|
LY Quantity
|
281,505
|
281,505
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Parameter : 3 - EMEA
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
16,625,870
|
16,625,870
|
Pass
|
2
|
Last Year Shipped YTD
|
13,369,491
|
13,369,491
|
Pass
|
3
|
Current Year Budget YTD
|
16,815,932
|
16,815,932
|
Pass
|
4
|
Total Open Revenue
|
23,467,993
|
23,240,851
|
Pass
|
5
|
Total Shipped Current Year
|
40,093,863
|
39,866,720
|
Pass
|
6
|
Total Shipped Last Year
|
61,654,111
|
61,654,111
|
Pass
|
7
|
Total Budget Current Year
|
75,557,744
|
75,557,744
|
Pass
|
8
|
TY Quantity
|
1,307,942
|
1,307,942
|
Pass
|
9
|
LY Quantity
|
1,064,387
|
1,064,387
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Parameter : 1 - North America - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
50,640,655
|
47,963,520
|
Pass
|
2
|
Last Year Shipped MTD
|
52,956,371
|
52,956,371
|
Pass
|
3
|
Current Year Budget MTD
|
57,632,012
|
57,632,012
|
Pass
|
4
|
TY Quantity
|
4,424,073
|
4,116,218
|
Pass
|
5
|
LY Quantity
|
4,466,148
|
4,466,148
|
Pass
|
6
|
Budget Quantity
|
0
|
0
|
Pass
|
Parameter : 2 - Emerging Market - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
1,822,421
|
1,822,421
|
Pass
|
2
|
Last Year Shipped MTD
|
2,159,396
|
2,159,396
|
Pass
|
3
|
Current Year Budget MTD
|
2,201,324
|
2,201,324
|
Pass
|
4
|
TY Quantity
|
123,061
|
123,061
|
Pass
|
5
|
LY Quantity
|
166,693
|
166,693
|
Pass
|
6
|
Budget Quantity
|
0
|
0
|
Pass
|
Parameter : 3 - EMEA - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
6,293,016
|
6,293,016
|
Pass
|
2
|
Last Year Shipped MTD
|
6,348,184
|
6,348,184
|
Pass
|
3
|
Current Year Budget MTD
|
6,190,189
|
6,190,189
|
Pass
|
4
|
TY Quantity
|
469,414
|
469,414
|
Pass
|
5
|
LY Quantity
|
468,476
|
468,476
|
Pass
|
6
|
Budget Quantity
|
0
|
0
|
Pass
|
Note: We have validated the Modified report with Old instance in BIBO 4.0 Production server (i.e., instance of 04/23/2013 with 04/13/2013). So the values for Shipped, Open and their respective values would not match exactly. Any near-by values is considered as successfully validated. Detail level Validation will be done by NEC.
Product Mix Sub Report Validation
Test Conducted
Grouping: North America > Headwear
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
100,084,674
|
100,084,674
|
Pass
|
2
|
Open
|
114,053,567
|
119,993,982
|
Pass
|
3
|
Total Revenue YTD
|
214,138,241
|
220,078,656
|
Pass
|
4
|
Last Year Shipped YTD
|
102,257,605
|
102,257,605
|
Pass
|
5
|
Current Year Budget YTD
|
125,747,439
|
125,747,439
|
Pass
|
6
|
TY Quantity
|
8,565,266
|
8,565,266
|
Pass
|
7
|
LY Quantity
|
9,182,863
|
9,182,863
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > MLB PROPERTIES > Apparel - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
8,139,552
|
5,883,014
|
Pass
|
2
|
Open
|
421
|
0
|
Pass
|
3
|
Total Revenue MTD
|
8,139,974
|
5,883,014
|
Pass
|
4
|
Last Year Shipped MTD
|
79,920
|
79,920
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
834,649
|
577,219
|
Pass
|
7
|
LY Quantity
|
6,310
|
6,310
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > MLB PROPERTIES > United States Sales >Apparel
SNo
|
Test Case
|
Value in Production Report
|
Value in Development report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
4,379,764
|
4,379,764
|
Pass
|
2
|
Open
|
2.313,438
|
2,376,575
|
Pass
|
3
|
Total Revenue YTD
|
6,693,202
|
6,756,339
|
Pass
|
4
|
Last Year Shipped YTD
|
0
|
0
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
346,934
|
346,934
|
Pass
|
7
|
LY Quantity
|
0
|
75
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Segment Sub Report Validation
Test Conducted
Grouping: Emerging Market > MLB PROPERTIES > TASTEMAKER
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
5,151
|
5,151
|
Pass
|
2
|
Open
|
3,553
|
4,851
|
Pass
|
3
|
Total Revenue YTD
|
8,704
|
10,001
|
Pass
|
4
|
Last Year Shipped YTD
|
1,175
|
1,175
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
252
|
252
|
Pass
|
7
|
LY Quantity
|
44
|
44
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: Emerging Market > MLB PROPERTIES > CLUB/MASS/DISCOUNT - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
2,025
|
2,025
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
2,025
|
2,025
|
Pass
|
4
|
Last Year Shipped MTD
|
720
|
720
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
136
|
136
|
Pass
|
7
|
LY Quantity
|
30
|
30
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: Emerging Market > MLB PROPERTIES > MEXICO SALES > GOLDSTAR
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
522,581
|
522,581
|
Pass
|
2
|
Open
|
1,503,479
|
1,477,193
|
Pass
|
3
|
Total Revenue YTD
|
2,026,060
|
1,999,773
|
Pass
|
4
|
Last Year Shipped YTD
|
0
|
0
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
28,261
|
28,261
|
Pass
|
7
|
LY Quantity
|
0
|
0
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Sub Report Validation
Test Conducted
Grouping: Emerging Market > COMERCIAL DPORTENIS SA
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
515,147
|
515,147
|
Pass
|
2
|
Open
|
1,361,526
|
1,356,986
|
Pass
|
3
|
Total Revenue YTD
|
1,876,672
|
1,872,133
|
Pass
|
4
|
Last Year Shipped YTD
|
0
|
0
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
28,039
|
28,039
|
Pass
|
7
|
LY Quantity
|
0
|
0
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: Emerging Market > MLB PROPERTIES > COMERCIAL DPORTENIS SA - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
254,869
|
254,869
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
254,869
|
254,869
|
Pass
|
4
|
Last Year Shipped MTD
|
0
|
0
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
13,614
|
13,614
|
Pass
|
7
|
LY Quantity
|
0
|
0
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: Emerging Market > MLB PROPERTIES > MEXICO SALES > COMERCIAL DPORTENIS SA - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
242,320
|
242,320
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
242,320
|
242,320
|
Pass
|
4
|
Last Year Shipped MTD
|
0
|
0
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
12,949
|
12,949
|
Pass
|
7
|
LY Quantity
|
0
|
0
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Silhouette Sub Report Validation
Test Conducted
Grouping: EMEA > 950 - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
1,588,387
|
1,588,387
|
Pass
|
2
|
Open
|
5,246
|
396
|
Pass
|
3
|
Total Revenue YTD
|
1,593,633
|
1,588,784
|
Pass
|
4
|
Last Year Shipped YTD
|
1,881,583
|
1,881,583
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
112,672
|
112,672
|
Pass
|
7
|
LY Quantity
|
120,552
|
120,552
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: EMEA > MLB PROPERTIES > 3930 - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
224,395
|
224,395
|
Pass
|
2
|
Open
|
14,781
|
14,525
|
Pass
|
3
|
Total Revenue YTD
|
239,176
|
238,920
|
Pass
|
4
|
Last Year Shipped YTD
|
316,425
|
316,425
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
25,289
|
25,289
|
Pass
|
7
|
LY Quantity
|
34,870
|
34,870
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: EMEA > MLB PROPERTIES > EMEA SALES > 5950
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
5,971,696
|
5,971,696
|
Pass
|
2
|
Open
|
6,554,123
|
6,401,948
|
Pass
|
3
|
Total Revenue YTD
|
12,525,818
|
12,373,644
|
Pass
|
4
|
Last Year Shipped YTD
|
5,943,864
|
5,943,864
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
363,140
|
363,140
|
Pass
|
7
|
LY Quantity
|
354,525
|
354,525
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Collection Sub Report Validation
Test Conducted
Grouping: Emerging Market > CUSTOM 5950 - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
86,186
|
86,186
|
Pass
|
2
|
Open
|
3,052
|
394
|
Pass
|
3
|
Total Revenue YTD
|
89,238
|
86,580
|
Pass
|
4
|
Last Year Shipped YTD
|
148,014
|
148,014
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
4,519
|
4,519
|
Pass
|
7
|
LY Quantity
|
8,727
|
8,727
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: Emerging Market > MLB PROPERTIES > THE LEAGUE - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
54,298
|
54,298
|
Pass
|
2
|
Open
|
13,637
|
13,104
|
Pass
|
3
|
Total Revenue YTD
|
67,935
|
67,402
|
Pass
|
4
|
Last Year Shipped YTD
|
847
|
847
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
4,788
|
4,788
|
Pass
|
7
|
LY Quantity
|
93
|
93
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: Emerging Market > MLB PROPERTIES > APAC SALES > AC PERFORMANCE
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
61,216
|
61,216
|
Pass
|
2
|
Open
|
120,805
|
127,215
|
Pass
|
3
|
Total Revenue YTD
|
182,021
|
188,431
|
Pass
|
4
|
Last Year Shipped YTD
|
41,228
|
41,228
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
4,288
|
4,288
|
Pass
|
7
|
LY Quantity
|
2,821
|
2,821
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Reference Document(Specification)
2013-04-29 - 5579.900 - Spec - EPM Reports